Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 167622 |
| Missing cells | 752 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 37.1 MiB |
| Average record size in memory | 232.0 B |
Variable types
| NUM | 19 |
|---|---|
| CAT | 10 |
total distance (km) has a high cardinality: 2659 distinct values | High cardinality |
average speed (km/h) has a high cardinality: 4154 distinct values | High cardinality |
average temperature has a high cardinality: 528 distinct values | High cardinality |
average wind speed (m/s) has a high cardinality: 162 distinct values | High cardinality |
max/min gpx height has a high cardinality: 16341 distinct values | High cardinality |
maxgpsheight has a high cardinality: 11857 distinct values | High cardinality |
average wind load (1 to -1) has a high cardinality: 182 distinct values | High cardinality |
avg_heart_rate_cat_org has a high cardinality: 803 distinct values | High cardinality |
avg_heart_rate_cat_adj has a high cardinality: 703 distinct values | High cardinality |
uphill8end is highly correlated with uphill/downhill hys=8 (m) and 2 other fields | High correlation |
uphill/downhill hys=8 (m) is highly correlated with uphill8end and 2 other fields | High correlation |
uphill/downhill hys=0 (m) is highly correlated with uphill/downhill hys=8 (m) and 2 other fields | High correlation |
uphill0end is highly correlated with uphill/downhill hys=8 (m) and 2 other fields | High correlation |
uphill/downhill hys=8 (m) is highly skewed (γ1 = 99.33185539) | Skewed |
uphill8end is highly skewed (γ1 = 104.3464029) | Skewed |
uphill/downhill hys=0 (m) is highly skewed (γ1 = 92.11190209) | Skewed |
uphill0end is highly skewed (γ1 = 96.6644515) | Skewed |
total real energy (kJ) is highly skewed (γ1 = 281.5546879) | Skewed |
total estimated energy (kJ) is highly skewed (γ1 = 31.90478045) | Skewed |
average power (W) is highly skewed (γ1 = 185.9572907) | Skewed |
average estimated power (W) is highly skewed (γ1 = 32.10429658) | Skewed |
normalized real power (W) is highly skewed (γ1 = 43.83014039) | Skewed |
normalized estimated power (W) is highly skewed (γ1 = 53.48094336) | Skewed |
cumulative hr intensity score is highly skewed (γ1 = -409.3680887) | Skewed |
df_index has unique values | Unique |
uphill/downhill hys=8 (m) has 11316 (6.8%) zeros | Zeros |
uphill8end has 11702 (7.0%) zeros | Zeros |
average wind direction (deg) has 65199 (38.9%) zeros | Zeros |
total real energy (kJ) has 96372 (57.5%) zeros | Zeros |
average power (W) has 96294 (57.4%) zeros | Zeros |
normalized real power (W) has 96326 (57.5%) zeros | Zeros |
number_of_participants has 28050 (16.7%) zeros | Zeros |
avg slope length (m) has 73348 (43.8%) zeros | Zeros |
Reproduction
| Analysis started | 2021-10-14 01:11:19.960149 |
|---|---|
| Analysis finished | 2021-10-14 01:13:11.199975 |
| Duration | 1 minute and 51.24 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 167622 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83810.5 |
|---|---|
| Minimum | 0 |
| Maximum | 167621 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8381.05 |
| Q1 | 41905.25 |
| median | 83810.5 |
| Q3 | 125715.75 |
| 95-th percentile | 159239.95 |
| Maximum | 167621 |
| Range | 167621 |
| Interquartile range (IQR) | 83810.5 |
Descriptive statistics
| Standard deviation | 48388.44775 |
|---|---|
| Coefficient of variation (CV) | 0.5773554358 |
| Kurtosis | -1.2 |
| Mean | 83810.5 |
| Median Absolute Deviation (MAD) | 41905.5 |
| Skewness | -1.516506131e-17 |
| Sum | 1.404848363e+10 |
| Variance | 2341441876 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 123625 | 1 | < 0.1% | |
| 4823 | 1 | < 0.1% | |
| 27352 | 1 | < 0.1% | |
| 25305 | 1 | < 0.1% | |
| 31450 | 1 | < 0.1% | |
| 29403 | 1 | < 0.1% | |
| 19164 | 1 | < 0.1% | |
| 17117 | 1 | < 0.1% | |
| 23262 | 1 | < 0.1% | |
| Other values (167612) | 167612 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 167621 | 1 | < 0.1% | |
| 167620 | 1 | < 0.1% | |
| 167619 | 1 | < 0.1% | |
| 167618 | 1 | < 0.1% | |
| 167617 | 1 | < 0.1% |
user-id
Real number (ℝ≥0)
| Distinct | 1437 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4236.598394 |
|---|---|
| Minimum | 1 |
| Maximum | 8210 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1591 |
| Q1 | 1919 |
| median | 2798 |
| Q3 | 7563 |
| 95-th percentile | 8122 |
| Maximum | 8210 |
| Range | 8209 |
| Interquartile range (IQR) | 5644 |
Descriptive statistics
| Standard deviation | 2658.458945 |
|---|---|
| Coefficient of variation (CV) | 0.6274984546 |
| Kurtosis | -1.526379073 |
| Mean | 4236.598394 |
| Median Absolute Deviation (MAD) | 1204 |
| Skewness | 0.3608078996 |
| Sum | 710147096 |
| Variance | 7067403.962 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 7992 | 3088 | 1.8% | |
| 1770 | 1864 | 1.1% | |
| 7667 | 1782 | 1.1% | |
| 7563 | 1527 | 0.9% | |
| 7883 | 1412 | 0.8% | |
| 7633 | 1387 | 0.8% | |
| 7626 | 1242 | 0.7% | |
| 8065 | 1228 | 0.7% | |
| 8161 | 1208 | 0.7% | |
| 1755 | 1202 | 0.7% | |
| Other values (1427) | 151682 | 90.5% |
| Value | Count | Frequency (%) | |
| 1 | 2 | < 0.1% | |
| 6 | 449 | 0.3% | |
| 7 | 406 | 0.2% | |
| 13 | 288 | 0.2% | |
| 16 | 188 | 0.1% |
| Value | Count | Frequency (%) | |
| 8210 | 110 | 0.1% | |
| 8207 | 14 | < 0.1% | |
| 8199 | 746 | 0.4% | |
| 8191 | 774 | 0.5% | |
| 8186 | 98 | 0.1% |
m/v
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| M | |
|---|---|
| F |
| Value | Count | Frequency (%) | |
| M | 151750 | 90.5% | |
| F | 15872 | 9.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
weight
Real number (ℝ≥0)
| Distinct | 80 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 75.81507797 |
|---|---|
| Minimum | 0 |
| Maximum | 267 |
| Zeros | 658 |
| Zeros (%) | 0.4% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 59 |
| Q1 | 68 |
| median | 75 |
| Q3 | 83 |
| 95-th percentile | 95 |
| Maximum | 267 |
| Range | 267 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 13.20316512 |
|---|---|
| Coefficient of variation (CV) | 0.1741495949 |
| Kurtosis | 13.26068358 |
| Mean | 75.81507797 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.855320527 |
| Sum | 12708275 |
| Variance | 174.3235691 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 68 | 8544 | 5.1% | |
| 85 | 8134 | 4.9% | |
| 81 | 8082 | 4.8% | |
| 75 | 7658 | 4.6% | |
| 70 | 7571 | 4.5% | |
| 72 | 6846 | 4.1% | |
| 80 | 6424 | 3.8% | |
| 78 | 6277 | 3.7% | |
| 84 | 6077 | 3.6% | |
| 71 | 5876 | 3.5% | |
| Other values (70) | 96133 | 57.4% |
| Value | Count | Frequency (%) | |
| 0 | 658 | 0.4% | |
| 45 | 43 | < 0.1% | |
| 49 | 51 | < 0.1% | |
| 50 | 6 | < 0.1% | |
| 51 | 1277 | 0.8% |
| Value | Count | Frequency (%) | |
| 267 | 2 | < 0.1% | |
| 214 | 5 | < 0.1% | |
| 205 | 56 | < 0.1% | |
| 180 | 19 | < 0.1% | |
| 172 | 268 | 0.2% |
age
Real number (ℝ≥0)
| Distinct | 63 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 752 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.40496794 |
|---|---|
| Minimum | 0 |
| Maximum | 76 |
| Zeros | 33 |
| Zeros (%) | < 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 34 |
| median | 41 |
| Q3 | 49 |
| 95-th percentile | 62 |
| Maximum | 76 |
| Range | 76 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.79401958 |
|---|---|
| Coefficient of variation (CV) | 0.2606938278 |
| Kurtosis | -0.1306070381 |
| Mean | 41.40496794 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.2168545966 |
| Sum | 6909247 |
| Variance | 116.5108587 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 30 | 9556 | 5.7% | |
| 39 | 8985 | 5.4% | |
| 44 | 8410 | 5.0% | |
| 45 | 7735 | 4.6% | |
| 36 | 7456 | 4.4% | |
| 33 | 6657 | 4.0% | |
| 50 | 6509 | 3.9% | |
| 40 | 6346 | 3.8% | |
| 38 | 6289 | 3.8% | |
| 43 | 5452 | 3.3% | |
| Other values (53) | 93475 | 55.8% |
| Value | Count | Frequency (%) | |
| 0 | 33 | < 0.1% | |
| 14 | 2 | < 0.1% | |
| 15 | 146 | 0.1% | |
| 16 | 254 | 0.2% | |
| 17 | 1007 | 0.6% |
| Value | Count | Frequency (%) | |
| 76 | 47 | < 0.1% | |
| 74 | 13 | < 0.1% | |
| 73 | 316 | 0.2% | |
| 72 | 37 | < 0.1% | |
| 71 | 1 | < 0.1% |
length
Real number (ℝ≥0)
| Distinct | 60 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 179.2729833 |
|---|---|
| Minimum | 0 |
| Maximum | 248 |
| Zeros | 658 |
| Zeros (%) | 0.4% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 165 |
| Q1 | 175 |
| median | 180 |
| Q3 | 186 |
| 95-th percentile | 192 |
| Maximum | 248 |
| Range | 248 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 14.31349823 |
|---|---|
| Coefficient of variation (CV) | 0.07984191468 |
| Kurtosis | 96.74006834 |
| Mean | 179.2729833 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -8.019146739 |
| Sum | 30050096 |
| Variance | 204.8762317 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 180 | 14162 | 8.4% | |
| 178 | 12995 | 7.8% | |
| 188 | 9136 | 5.5% | |
| 191 | 8491 | 5.1% | |
| 179 | 7455 | 4.4% | |
| 186 | 7298 | 4.4% | |
| 176 | 7189 | 4.3% | |
| 177 | 7166 | 4.3% | |
| 185 | 7107 | 4.2% | |
| 170 | 6816 | 4.1% | |
| Other values (50) | 79807 | 47.6% |
| Value | Count | Frequency (%) | |
| 0 | 658 | 0.4% | |
| 60 | 53 | < 0.1% | |
| 69 | 34 | < 0.1% | |
| 104 | 19 | < 0.1% | |
| 105 | 54 | < 0.1% |
| Value | Count | Frequency (%) | |
| 248 | 56 | < 0.1% | |
| 208 | 56 | < 0.1% | |
| 205 | 232 | 0.1% | |
| 203 | 126 | 0.1% | |
| 202 | 61 | < 0.1% |
| Distinct | 2659 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 61 | 359 |
|---|---|
| 60,2 | 336 |
| 60 | 333 |
| 60,1 | 328 |
| 59,9 | 324 |
| Other values (2654) |
| Value | Count | Frequency (%) | |
| 61 | 359 | 0.2% | |
| 60,2 | 336 | 0.2% | |
| 60 | 333 | 0.2% | |
| 60,1 | 328 | 0.2% | |
| 59,9 | 324 | 0.2% | |
| 62,6 | 316 | 0.2% | |
| 62,4 | 308 | 0.2% | |
| 61,4 | 308 | 0.2% | |
| 55,3 | 307 | 0.2% | |
| 62,9 | 301 | 0.2% | |
| Other values (2649) | 164402 | 98.1% |
Unique
| Unique | 328 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 3.971274654 |
| Min length | 1 |
| Distinct | 4154 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 28,44 | 205 |
|---|---|
| 25,59 | 204 |
| 26,01 | 201 |
| 26,51 | 200 |
| 28,47 | 200 |
| Other values (4149) |
| Value | Count | Frequency (%) | |
| 28,44 | 205 | 0.1% | |
| 25,59 | 204 | 0.1% | |
| 26,01 | 201 | 0.1% | |
| 26,51 | 200 | 0.1% | |
| 28,47 | 200 | 0.1% | |
| 28,2 | 199 | 0.1% | |
| 0 | 199 | 0.1% | |
| 26,19 | 195 | 0.1% | |
| 26,35 | 192 | 0.1% | |
| 28,11 | 190 | 0.1% | |
| Other values (4144) | 165637 | 98.8% |
Unique
| Unique | 341 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 4.859362136 |
| Min length | 1 |
| Distinct | 3789 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 458.3105261 |
|---|---|
| Minimum | 0 |
| Maximum | 238637 |
| Zeros | 11316 |
| Zeros (%) | 6.8% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 38 |
| median | 202 |
| Q3 | 605 |
| 95-th percentile | 1708 |
| Maximum | 238637 |
| Range | 238637 |
| Interquartile range (IQR) | 567 |
Descriptive statistics
| Standard deviation | 1211.184628 |
|---|---|
| Coefficient of variation (CV) | 2.642716149 |
| Kurtosis | 15770.52884 |
| Mean | 458.3105261 |
| Median Absolute Deviation (MAD) | 186 |
| Skewness | 99.33185539 |
| Sum | 76822927 |
| Variance | 1466968.204 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 11316 | 6.8% | |
| 8 | 5189 | 3.1% | |
| 9 | 3710 | 2.2% | |
| 17 | 3052 | 1.8% | |
| 18 | 2104 | 1.3% | |
| 26 | 1579 | 0.9% | |
| 25 | 1379 | 0.8% | |
| 27 | 1300 | 0.8% | |
| 16 | 1277 | 0.8% | |
| 19 | 1226 | 0.7% | |
| Other values (3779) | 135490 | 80.8% |
| Value | Count | Frequency (%) | |
| 0 | 11316 | 6.8% | |
| 8 | 5189 | 3.1% | |
| 9 | 3710 | 2.2% | |
| 10 | 1222 | 0.7% | |
| 11 | 428 | 0.3% |
| Value | Count | Frequency (%) | |
| 238637 | 1 | < 0.1% | |
| 188676 | 1 | < 0.1% | |
| 164662 | 1 | < 0.1% | |
| 117178 | 2 | < 0.1% | |
| 96725 | 1 | < 0.1% |
| Distinct | 3706 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 451.2794084 |
|---|---|
| Minimum | 0 |
| Maximum | 238637 |
| Zeros | 11702 |
| Zeros (%) | 7.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 38 |
| median | 203 |
| Q3 | 601 |
| 95-th percentile | 1683 |
| Maximum | 238637 |
| Range | 238637 |
| Interquartile range (IQR) | 563 |
Descriptive statistics
| Standard deviation | 1205.596267 |
|---|---|
| Coefficient of variation (CV) | 2.671507373 |
| Kurtosis | 16891.978 |
| Mean | 451.2794084 |
| Median Absolute Deviation (MAD) | 186 |
| Skewness | 104.3464029 |
| Sum | 75644357 |
| Variance | 1453462.359 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 11702 | 7.0% | |
| 8 | 5466 | 3.3% | |
| 9 | 3775 | 2.3% | |
| 17 | 3768 | 2.2% | |
| 18 | 1954 | 1.2% | |
| 25 | 1788 | 1.1% | |
| 26 | 1665 | 1.0% | |
| 27 | 1321 | 0.8% | |
| 35 | 1087 | 0.6% | |
| 10 | 1039 | 0.6% | |
| Other values (3696) | 134057 | 80.0% |
| Value | Count | Frequency (%) | |
| 0 | 11702 | 7.0% | |
| 8 | 5466 | 3.3% | |
| 9 | 3775 | 2.3% | |
| 10 | 1039 | 0.6% | |
| 11 | 276 | 0.2% |
| Value | Count | Frequency (%) | |
| 238637 | 1 | < 0.1% | |
| 201283 | 1 | < 0.1% | |
| 158734 | 1 | < 0.1% | |
| 117178 | 2 | < 0.1% | |
| 102376 | 1 | < 0.1% |
| Distinct | 4131 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 663.5069203 |
|---|---|
| Minimum | 0 |
| Maximum | 238637 |
| Zeros | 195 |
| Zeros (%) | 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 57 |
| Q1 | 200 |
| median | 422 |
| Q3 | 867 |
| 95-th percentile | 2004 |
| Maximum | 238637 |
| Range | 238637 |
| Interquartile range (IQR) | 667 |
Descriptive statistics
| Standard deviation | 1241.494926 |
|---|---|
| Coefficient of variation (CV) | 1.871110742 |
| Kurtosis | 14238.05815 |
| Mean | 663.5069203 |
| Median Absolute Deviation (MAD) | 272 |
| Skewness | 92.11190209 |
| Sum | 111218357 |
| Variance | 1541309.651 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 198 | 372 | 0.2% | |
| 144 | 328 | 0.2% | |
| 172 | 324 | 0.2% | |
| 306 | 312 | 0.2% | |
| 160 | 308 | 0.2% | |
| 183 | 300 | 0.2% | |
| 134 | 297 | 0.2% | |
| 148 | 296 | 0.2% | |
| 177 | 295 | 0.2% | |
| 142 | 294 | 0.2% | |
| Other values (4121) | 164496 | 98.1% |
| Value | Count | Frequency (%) | |
| 0 | 195 | 0.1% | |
| 1 | 23 | < 0.1% | |
| 2 | 49 | < 0.1% | |
| 3 | 69 | < 0.1% | |
| 4 | 113 | 0.1% |
| Value | Count | Frequency (%) | |
| 238637 | 1 | < 0.1% | |
| 188676 | 1 | < 0.1% | |
| 164718 | 1 | < 0.1% | |
| 117427 | 2 | < 0.1% | |
| 96729 | 1 | < 0.1% |
| Distinct | 4035 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 656.7462684 |
|---|---|
| Minimum | 0 |
| Maximum | 238637 |
| Zeros | 265 |
| Zeros (%) | 0.2% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 58 |
| Q1 | 200 |
| median | 421 |
| Q3 | 864 |
| 95-th percentile | 1983 |
| Maximum | 238637 |
| Range | 238637 |
| Interquartile range (IQR) | 664 |
Descriptive statistics
| Standard deviation | 1236.108261 |
|---|---|
| Coefficient of variation (CV) | 1.882170208 |
| Kurtosis | 15232.38209 |
| Mean | 656.7462684 |
| Median Absolute Deviation (MAD) | 271 |
| Skewness | 96.6644515 |
| Sum | 110085123 |
| Variance | 1527963.633 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 182 | 333 | 0.2% | |
| 146 | 319 | 0.2% | |
| 150 | 319 | 0.2% | |
| 200 | 317 | 0.2% | |
| 218 | 316 | 0.2% | |
| 156 | 313 | 0.2% | |
| 208 | 308 | 0.2% | |
| 145 | 303 | 0.2% | |
| 183 | 298 | 0.2% | |
| 132 | 298 | 0.2% | |
| Other values (4025) | 164498 | 98.1% |
| Value | Count | Frequency (%) | |
| 0 | 265 | 0.2% | |
| 1 | 47 | < 0.1% | |
| 2 | 65 | < 0.1% | |
| 3 | 78 | < 0.1% | |
| 4 | 102 | 0.1% |
| Value | Count | Frequency (%) | |
| 238637 | 1 | < 0.1% | |
| 201283 | 1 | < 0.1% | |
| 158762 | 1 | < 0.1% | |
| 117435 | 2 | < 0.1% | |
| 102391 | 1 | < 0.1% |
| Distinct | 528 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 18,1 | 786 |
| 18,4 | 778 |
| 17,7 | 752 |
| 17 | 746 |
| Other values (523) |
| Value | Count | Frequency (%) | |
| 0 | 28986 | 17.3% | |
| 18,1 | 786 | 0.5% | |
| 18,4 | 778 | 0.5% | |
| 17,7 | 752 | 0.4% | |
| 17 | 746 | 0.4% | |
| 19,3 | 735 | 0.4% | |
| 17,4 | 730 | 0.4% | |
| 20,6 | 728 | 0.4% | |
| 17,8 | 724 | 0.4% | |
| 18,3 | 724 | 0.4% | |
| Other values (518) | 131933 | 78.7% |
Unique
| Unique | 43 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 3.149377767 |
| Min length | 1 |
| Distinct | 162 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 2 | 2582 |
| 1,9 | 2569 |
| 2,1 | 2474 |
| 1,7 | 2432 |
| Other values (157) |
| Value | Count | Frequency (%) | |
| 0 | 65222 | 38.9% | |
| 2 | 2582 | 1.5% | |
| 1,9 | 2569 | 1.5% | |
| 2,1 | 2474 | 1.5% | |
| 1,7 | 2432 | 1.5% | |
| 2,6 | 2419 | 1.4% | |
| 1,6 | 2416 | 1.4% | |
| 1,5 | 2409 | 1.4% | |
| 1,8 | 2387 | 1.4% | |
| 2,5 | 2322 | 1.4% | |
| Other values (152) | 80390 | 48.0% |
Unique
| Unique | 13 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.100702772 |
| Min length | 1 |
| Distinct | 360 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 110.9212574 |
|---|---|
| Minimum | 0 |
| Maximum | 359 |
| Zeros | 65199 |
| Zeros (%) | 38.9% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 76 |
| Q3 | 216 |
| 95-th percentile | 311 |
| Maximum | 359 |
| Range | 359 |
| Interquartile range (IQR) | 216 |
Descriptive statistics
| Standard deviation | 114.1309145 |
|---|---|
| Coefficient of variation (CV) | 1.028936358 |
| Kurtosis | -1.25104972 |
| Mean | 110.9212574 |
| Median Absolute Deviation (MAD) | 76 |
| Skewness | 0.4777341301 |
| Sum | 18592843 |
| Variance | 13025.86565 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 65199 | 38.9% | |
| 240 | 520 | 0.3% | |
| 221 | 504 | 0.3% | |
| 233 | 493 | 0.3% | |
| 235 | 491 | 0.3% | |
| 222 | 487 | 0.3% | |
| 230 | 485 | 0.3% | |
| 210 | 484 | 0.3% | |
| 203 | 483 | 0.3% | |
| 226 | 481 | 0.3% | |
| Other values (350) | 97995 | 58.5% |
| Value | Count | Frequency (%) | |
| 0 | 65199 | 38.9% | |
| 1 | 78 | < 0.1% | |
| 2 | 100 | 0.1% | |
| 3 | 88 | 0.1% | |
| 4 | 118 | 0.1% |
| Value | Count | Frequency (%) | |
| 359 | 23 | < 0.1% | |
| 358 | 48 | < 0.1% | |
| 357 | 63 | < 0.1% | |
| 356 | 81 | < 0.1% | |
| 355 | 70 | < 0.1% |
| Distinct | 16341 |
|---|---|
| Distinct (%) | 9.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | 6610 |
|---|---|
| 13 | 238 |
| 11,2 | 238 |
| 9,8 | 233 |
| 20,6 | 232 |
| Other values (16336) |
| Value | Count | Frequency (%) | |
| 0 | 6610 | 3.9% | |
| 13 | 238 | 0.1% | |
| 11,2 | 238 | 0.1% | |
| 9,8 | 233 | 0.1% | |
| 20,6 | 232 | 0.1% | |
| 10,8 | 232 | 0.1% | |
| 10 | 231 | 0.1% | |
| 14 | 220 | 0.1% | |
| 6 | 219 | 0.1% | |
| 9,6 | 219 | 0.1% | |
| Other values (16331) | 158950 | 94.8% |
Unique
| Unique | 5150 ? |
|---|---|
| Unique (%) | 3.1% |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.111441219 |
| Min length | 1 |
| Distinct | 11857 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | 1303 |
|---|---|
| -3 | 655 |
| -2 | 626 |
| -0,2 | 616 |
| 1 | 600 |
| Other values (11852) |
| Value | Count | Frequency (%) | |
| 0 | 1303 | 0.8% | |
| -3 | 655 | 0.4% | |
| -2 | 626 | 0.4% | |
| -0,2 | 616 | 0.4% | |
| 1 | 600 | 0.4% | |
| -1 | 590 | 0.4% | |
| -0,8 | 582 | 0.3% | |
| -2,4 | 582 | 0.3% | |
| -0,6 | 572 | 0.3% | |
| 0,4 | 551 | 0.3% | |
| Other values (11847) | 160945 | 96.0% |
Unique
| Unique | 3865 ? |
|---|---|
| Unique (%) | 2.3% |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 3.927479686 |
| Min length | 1 |
| Distinct | 5289 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 952.0742862 |
|---|---|
| Minimum | 0 |
| Maximum | 10508164 |
| Zeros | 96372 |
| Zeros (%) | 57.5% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1545 |
| 95-th percentile | 2967.95 |
| Maximum | 10508164 |
| Range | 10508164 |
| Interquartile range (IQR) | 1545 |
Descriptive statistics
| Standard deviation | 36668.71405 |
|---|---|
| Coefficient of variation (CV) | 38.51455142 |
| Kurtosis | 80479.55897 |
| Mean | 952.0742862 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 281.5546879 |
| Sum | 159588596 |
| Variance | 1344594590 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 96372 | 57.5% | |
| 1392 | 81 | < 0.1% | |
| 1469 | 79 | < 0.1% | |
| 1480 | 79 | < 0.1% | |
| 1733 | 74 | < 0.1% | |
| 1494 | 74 | < 0.1% | |
| 2003 | 72 | < 0.1% | |
| 1560 | 72 | < 0.1% | |
| 1592 | 71 | < 0.1% | |
| 1495 | 71 | < 0.1% | |
| Other values (5279) | 70577 | 42.1% |
| Value | Count | Frequency (%) | |
| 0 | 96372 | 57.5% | |
| 1 | 28 | < 0.1% | |
| 2 | 18 | < 0.1% | |
| 3 | 9 | < 0.1% | |
| 4 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10508164 | 2 | < 0.1% | |
| 1862548 | 1 | < 0.1% | |
| 505549 | 3 | < 0.1% | |
| 203606 | 1 | < 0.1% | |
| 95778 | 1 | < 0.1% |
| Distinct | 5143 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1254.472736 |
|---|---|
| Minimum | -1543 |
| Maximum | 154850 |
| Zeros | 223 |
| Zeros (%) | 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -1543 |
|---|---|
| 5-th percentile | 118 |
| Q1 | 761 |
| median | 1129 |
| Q3 | 1616 |
| 95-th percentile | 2691 |
| Maximum | 154850 |
| Range | 156393 |
| Interquartile range (IQR) | 855 |
Descriptive statistics
| Standard deviation | 893.4703636 |
|---|---|
| Coefficient of variation (CV) | 0.7122278052 |
| Kurtosis | 5223.281528 |
| Mean | 1254.472736 |
| Median Absolute Deviation (MAD) | 418 |
| Skewness | 31.90478045 |
| Sum | 210277229 |
| Variance | 798289.2907 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 223 | 0.1% | |
| 914 | 158 | 0.1% | |
| 1016 | 158 | 0.1% | |
| 1116 | 157 | 0.1% | |
| 1099 | 152 | 0.1% | |
| 1055 | 151 | 0.1% | |
| 1077 | 150 | 0.1% | |
| 942 | 146 | 0.1% | |
| 864 | 143 | 0.1% | |
| 955 | 142 | 0.1% | |
| Other values (5133) | 166042 | 99.1% |
| Value | Count | Frequency (%) | |
| -1543 | 1 | < 0.1% | |
| -1348 | 1 | < 0.1% | |
| -1150 | 1 | < 0.1% | |
| -1146 | 1 | < 0.1% | |
| -1126 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 154850 | 1 | < 0.1% | |
| 24540 | 2 | < 0.1% | |
| 20674 | 1 | < 0.1% | |
| 17303 | 1 | < 0.1% | |
| 16819 | 2 | < 0.1% |
| Distinct | 50334 |
|---|---|
| Distinct (%) | 30.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94426.11477 |
|---|---|
| Minimum | 0 |
| Maximum | 730107252 |
| Zeros | 96294 |
| Zeros (%) | 57.4% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 164058.75 |
| 95-th percentile | 222215 |
| Maximum | 730107252 |
| Range | 730107252 |
| Interquartile range (IQR) | 164058.75 |
Descriptive statistics
| Standard deviation | 3394881.246 |
|---|---|
| Coefficient of variation (CV) | 35.9527791 |
| Kurtosis | 35824.50566 |
| Mean | 94426.11477 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 185.9572907 |
| Sum | 1.582789421e+10 |
| Variance | 1.152521867e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 96294 | 57.4% | |
| 162840 | 46 | < 0.1% | |
| 165651 | 37 | < 0.1% | |
| 203071 | 36 | < 0.1% | |
| 205038 | 36 | < 0.1% | |
| 162761 | 34 | < 0.1% | |
| 208485 | 34 | < 0.1% | |
| 211735 | 34 | < 0.1% | |
| 221477 | 34 | < 0.1% | |
| 208851 | 34 | < 0.1% | |
| Other values (50324) | 71003 | 42.4% |
| Value | Count | Frequency (%) | |
| 0 | 96294 | 57.4% | |
| 3 | 25 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 8 | 4 | < 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 730107252 | 2 | < 0.1% | |
| 525392672 | 3 | < 0.1% | |
| 188033983 | 1 | < 0.1% | |
| 21238839 | 1 | < 0.1% | |
| 13179319 | 1 | < 0.1% |
| Distinct | 95678 |
|---|---|
| Distinct (%) | 57.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 119574.6987 |
|---|---|
| Minimum | -643339 |
| Maximum | 8690989 |
| Zeros | 200 |
| Zeros (%) | 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -643339 |
|---|---|
| 5-th percentile | 38738.45 |
| Q1 | 89359.25 |
| median | 116919 |
| Q3 | 145172.75 |
| 95-th percentile | 197817.1 |
| Maximum | 8690989 |
| Range | 9334328 |
| Interquartile range (IQR) | 55813.5 |
Descriptive statistics
| Standard deviation | 73182.0355 |
|---|---|
| Coefficient of variation (CV) | 0.6120194013 |
| Kurtosis | 2789.574354 |
| Mean | 119574.6987 |
| Median Absolute Deviation (MAD) | 27902 |
| Skewness | 32.10429658 |
| Sum | 2.004335014e+10 |
| Variance | 5355610320 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 200 | 0.1% | |
| 141352 | 24 | < 0.1% | |
| 146744 | 23 | < 0.1% | |
| 115225 | 21 | < 0.1% | |
| 138694 | 21 | < 0.1% | |
| 158198 | 21 | < 0.1% | |
| 153339 | 21 | < 0.1% | |
| 111716 | 21 | < 0.1% | |
| 149536 | 20 | < 0.1% | |
| 110571 | 20 | < 0.1% | |
| Other values (95668) | 167230 | 99.8% |
| Value | Count | Frequency (%) | |
| -643339 | 1 | < 0.1% | |
| -635728 | 2 | < 0.1% | |
| -428132 | 2 | < 0.1% | |
| -393397 | 1 | < 0.1% | |
| -360039 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8690989 | 2 | < 0.1% | |
| 4374261 | 2 | < 0.1% | |
| 4247700 | 2 | < 0.1% | |
| 3641539 | 2 | < 0.1% | |
| 3570980 | 2 | < 0.1% |
| Distinct | 494 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 84.57364188 |
|---|---|
| Minimum | 0 |
| Maximum | 18724 |
| Zeros | 96326 |
| Zeros (%) | 57.5% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 186 |
| 95-th percentile | 243 |
| Maximum | 18724 |
| Range | 18724 |
| Interquartile range (IQR) | 186 |
Descriptive statistics
| Standard deviation | 156.9798861 |
|---|---|
| Coefficient of variation (CV) | 1.856132509 |
| Kurtosis | 3821.328527 |
| Mean | 84.57364188 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 43.83014039 |
| Sum | 14176403 |
| Variance | 24642.68464 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 96326 | 57.5% | |
| 203 | 784 | 0.5% | |
| 191 | 761 | 0.5% | |
| 182 | 732 | 0.4% | |
| 189 | 723 | 0.4% | |
| 196 | 719 | 0.4% | |
| 186 | 717 | 0.4% | |
| 198 | 716 | 0.4% | |
| 200 | 706 | 0.4% | |
| 223 | 698 | 0.4% | |
| Other values (484) | 64740 | 38.6% |
| Value | Count | Frequency (%) | |
| 0 | 96326 | 57.5% | |
| 1 | 38 | < 0.1% | |
| 2 | 13 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 18724 | 1 | < 0.1% | |
| 17919 | 1 | < 0.1% | |
| 13817 | 1 | < 0.1% | |
| 12639 | 1 | < 0.1% | |
| 11730 | 1 | < 0.1% |
| Distinct | 1098 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 218.606937 |
|---|---|
| Minimum | 0 |
| Maximum | 108703 |
| Zeros | 200 |
| Zeros (%) | 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 85 |
| Q1 | 140 |
| median | 181 |
| Q3 | 232 |
| 95-th percentile | 345 |
| Maximum | 108703 |
| Range | 108703 |
| Interquartile range (IQR) | 92 |
Descriptive statistics
| Standard deviation | 1045.943502 |
|---|---|
| Coefficient of variation (CV) | 4.784585138 |
| Kurtosis | 3343.9457 |
| Mean | 218.606937 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 53.48094336 |
| Sum | 36643332 |
| Variance | 1093997.809 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 168 | 1116 | 0.7% | |
| 172 | 1093 | 0.7% | |
| 155 | 1085 | 0.6% | |
| 163 | 1081 | 0.6% | |
| 154 | 1079 | 0.6% | |
| 164 | 1070 | 0.6% | |
| 182 | 1060 | 0.6% | |
| 156 | 1054 | 0.6% | |
| 165 | 1053 | 0.6% | |
| 167 | 1053 | 0.6% | |
| Other values (1088) | 156878 | 93.6% |
| Value | Count | Frequency (%) | |
| 0 | 200 | 0.1% | |
| 2 | 2 | < 0.1% | |
| 4 | 7 | < 0.1% | |
| 5 | 9 | < 0.1% | |
| 6 | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 108703 | 1 | < 0.1% | |
| 89284 | 2 | < 0.1% | |
| 80363 | 2 | < 0.1% | |
| 73674 | 2 | < 0.1% | |
| 56131 | 2 | < 0.1% |
| Distinct | 219 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.202372004 |
|---|---|
| Minimum | 0 |
| Maximum | 452 |
| Zeros | 28050 |
| Zeros (%) | 16.7% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 11 |
| Maximum | 452 |
| Range | 452 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 9.716306017 |
|---|---|
| Coefficient of variation (CV) | 3.034096603 |
| Kurtosis | 279.1106459 |
| Mean | 3.202372004 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 13.31443745 |
| Sum | 536788 |
| Variance | 94.40660261 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 80760 | 48.2% | |
| 0 | 28050 | 16.7% | |
| 2 | 21524 | 12.8% | |
| 3 | 8188 | 4.9% | |
| 4 | 4999 | 3.0% | |
| 5 | 3789 | 2.3% | |
| 6 | 2881 | 1.7% | |
| 7 | 2415 | 1.4% | |
| 8 | 2049 | 1.2% | |
| 9 | 1830 | 1.1% | |
| Other values (209) | 11137 | 6.6% |
| Value | Count | Frequency (%) | |
| 0 | 28050 | 16.7% | |
| 1 | 80760 | 48.2% | |
| 2 | 21524 | 12.8% | |
| 3 | 8188 | 4.9% | |
| 4 | 4999 | 3.0% |
| Value | Count | Frequency (%) | |
| 452 | 1 | < 0.1% | |
| 383 | 1 | < 0.1% | |
| 345 | 1 | < 0.1% | |
| 330 | 1 | < 0.1% | |
| 317 | 1 | < 0.1% |
| Distinct | 182 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| -0,01 | |
| 0,01 | |
| 0,02 | |
| -0,02 | |
| Other values (177) |
| Value | Count | Frequency (%) | |
| 0 | 38896 | 23.2% | |
| -0,01 | 22063 | 13.2% | |
| 0,01 | 21543 | 12.9% | |
| 0,02 | 10445 | 6.2% | |
| -0,02 | 10401 | 6.2% | |
| 0,03 | 5863 | 3.5% | |
| -0,03 | 5746 | 3.4% | |
| 0,04 | 3887 | 2.3% | |
| -0,04 | 3670 | 2.2% | |
| 0,05 | 2848 | 1.7% | |
| Other values (172) | 42260 | 25.2% |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 3.661935784 |
| Min length | 1 |
| Distinct | 85430 |
|---|---|
| Distinct (%) | 51.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -126620.3839 |
|---|---|
| Minimum | -3.214664261e+10 |
| Maximum | 211992640 |
| Zeros | 199 |
| Zeros (%) | 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -3.214664261e+10 |
|---|---|
| 5-th percentile | 6904 |
| Q1 | 25885.25 |
| median | 44718.5 |
| Q3 | 72208 |
| 95-th percentile | 158584.45 |
| Maximum | 211992640 |
| Range | 3.235863525e+10 |
| Interquartile range (IQR) | 46322.75 |
Descriptive statistics
| Standard deviation | 78521415.88 |
|---|---|
| Coefficient of variation (CV) | -620.1325054 |
| Kurtosis | 167595.5574 |
| Mean | -126620.3839 |
| Median Absolute Deviation (MAD) | 21830.5 |
| Skewness | -409.3680887 |
| Sum | -2.122436198e+10 |
| Variance | 6.165612751e+15 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 199 | 0.1% | |
| 56586 | 15 | < 0.1% | |
| 83477 | 14 | < 0.1% | |
| 13421 | 14 | < 0.1% | |
| 36406 | 13 | < 0.1% | |
| 25895 | 13 | < 0.1% | |
| 30784 | 12 | < 0.1% | |
| 35780 | 12 | < 0.1% | |
| 28526 | 12 | < 0.1% | |
| 3573 | 12 | < 0.1% | |
| Other values (85420) | 167306 | 99.8% |
| Value | Count | Frequency (%) | |
| -3.214664261e+10 | 1 | < 0.1% | |
| -67782472 | 2 | < 0.1% | |
| -1048388 | 1 | < 0.1% | |
| 0 | 199 | 0.1% | |
| 103 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 211992640 | 1 | < 0.1% | |
| 81628634 | 2 | < 0.1% | |
| 46155797 | 3 | < 0.1% | |
| 36128217 | 1 | < 0.1% | |
| 33313290 | 1 | < 0.1% |
| Distinct | 803 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 9 | 4019 |
|---|---|
| 1 | 3168 |
| 2 | 601 |
| 3,96 | 468 |
| 4,22 | 446 |
| Other values (798) |
| Value | Count | Frequency (%) | |
| 9 | 4019 | 2.4% | |
| 1 | 3168 | 1.9% | |
| 2 | 601 | 0.4% | |
| 3,96 | 468 | 0.3% | |
| 4,22 | 446 | 0.3% | |
| 4,08 | 444 | 0.3% | |
| 4,1 | 442 | 0.3% | |
| 3,9 | 436 | 0.3% | |
| 4,12 | 436 | 0.3% | |
| 3,79 | 435 | 0.3% | |
| Other values (793) | 156727 | 93.5% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 3.745665843 |
| Min length | 1 |
| Distinct | 703 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 2 | 5191 |
|---|---|
| 9 | 4022 |
| 2,01 | 598 |
| 2,02 | 533 |
| 3,19 | 507 |
| Other values (698) |
| Value | Count | Frequency (%) | |
| 2 | 5191 | 3.1% | |
| 9 | 4022 | 2.4% | |
| 2,01 | 598 | 0.4% | |
| 2,02 | 533 | 0.3% | |
| 3,19 | 507 | 0.3% | |
| 2,99 | 506 | 0.3% | |
| 2,97 | 500 | 0.3% | |
| 3,05 | 500 | 0.3% | |
| 3,21 | 499 | 0.3% | |
| 2,04 | 496 | 0.3% | |
| Other values (693) | 154270 | 92.0% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 3.721396953 |
| Min length | 1 |
| Distinct | 5146 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2297.915214 |
|---|---|
| Minimum | 0 |
| Maximum | 180700 |
| Zeros | 73348 |
| Zeros (%) | 43.8% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1200 |
| Q3 | 2950 |
| 95-th percentile | 8550 |
| Maximum | 180700 |
| Range | 180700 |
| Interquartile range (IQR) | 2950 |
Descriptive statistics
| Standard deviation | 4375.183206 |
|---|---|
| Coefficient of variation (CV) | 1.903979389 |
| Kurtosis | 149.8999663 |
| Mean | 2297.915214 |
| Median Absolute Deviation (MAD) | 1200 |
| Skewness | 8.113448453 |
| Sum | 385181144 |
| Variance | 19142228.09 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 73348 | 43.8% | |
| 1100 | 2052 | 1.2% | |
| 1200 | 1835 | 1.1% | |
| 1300 | 1626 | 1.0% | |
| 1000 | 1517 | 0.9% | |
| 1400 | 1432 | 0.9% | |
| 1600 | 1264 | 0.8% | |
| 1500 | 1239 | 0.7% | |
| 1800 | 1136 | 0.7% | |
| 1700 | 1076 | 0.6% | |
| Other values (5136) | 81097 | 48.4% |
| Value | Count | Frequency (%) | |
| 0 | 73348 | 43.8% | |
| 100 | 126 | 0.1% | |
| 130 | 1 | < 0.1% | |
| 133 | 2 | < 0.1% | |
| 147 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 180700 | 1 | < 0.1% | |
| 180400 | 1 | < 0.1% | |
| 158900 | 1 | < 0.1% | |
| 157700 | 1 | < 0.1% | |
| 137300 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | user-id | m/v | weight | age | length | total distance (km) | average speed (km/h) | uphill/downhill hys=8 (m) | uphill8end | uphill/downhill hys=0 (m) | uphill0end | average temperature | average wind speed (m/s) | average wind direction (deg) | max/min gpx height | maxgpsheight | total real energy (kJ) | total estimated energy (kJ) | average power (W) | average estimated power (W) | normalized real power (W) | normalized estimated power (W) | number_of_participants | average wind load (1 to -1) | cumulative hr intensity score | avg_heart_rate_cat_org | avg_heart_rate_cat_adj | avg slope length (m) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 92645 | 1748 | M | 79 | 46.0 | 179 | 87,6 | 26,47 | 258 | 269 | 503 | 506 | 24,7 | 0 | 0 | 97,6 | -69,4 | 0 | 1205 | 0 | 101376 | 0 | 132 | 2 | 0,01 | 40951 | 3,32 | 3,13 | 13800 |
| 1 | 84976 | 1748 | M | 79 | 46.0 | 179 | 75,6 | 25,76 | 178 | 191 | 393 | 411 | 9,6 | 0 | 0 | 100,2 | -3,6 | 0 | 1083 | 0 | 103139 | 0 | 127 | 2 | 0,01 | 25771 | 2,24 | 2,34 | 1300 |
| 2 | 92619 | 1748 | M | 79 | 46.0 | 179 | 75,6 | 25,76 | 178 | 191 | 393 | 411 | 9,6 | 0 | 0 | 100,2 | -3,6 | 0 | 1083 | 0 | 103139 | 0 | 127 | 2 | 0,01 | 25771 | 2,24 | 2,34 | 1300 |
| 3 | 85041 | 1748 | M | 79 | 46.0 | 179 | 80,7 | 21,75 | 718 | 701 | 911 | 893 | 25 | 0 | 0 | 553,2 | -2 | 1187 | 998 | 89445 | 75194 | 118 | 179 | 2 | 0,01 | 53457 | 3,06 | 2,96 | 7900 |
| 4 | 92684 | 1748 | M | 79 | 46.0 | 179 | 80,7 | 21,75 | 718 | 701 | 911 | 893 | 25 | 0 | 0 | 553,2 | -2 | 1187 | 998 | 89445 | 75194 | 118 | 179 | 2 | 0,01 | 53457 | 3,06 | 2,96 | 7900 |
| 5 | 85058 | 1748 | M | 79 | 46.0 | 179 | 87,5 | 25,22 | 276 | 260 | 523 | 509 | 21,4 | 0 | 0 | 126,6 | 12,4 | 1698 | 1217 | 136233 | 97634 | 152 | 171 | 2 | 0,01 | 76020 | 4,45 | 4,26 | 2400 |
| 6 | 92701 | 1748 | M | 79 | 46.0 | 179 | 87,5 | 25,22 | 276 | 260 | 523 | 509 | 21,4 | 0 | 0 | 126,6 | 12,4 | 1698 | 1217 | 136233 | 97634 | 152 | 171 | 2 | 0,01 | 76020 | 4,45 | 4,26 | 2400 |
| 7 | 84979 | 1748 | M | 79 | 46.0 | 179 | 74,4 | 25,6 | 166 | 176 | 391 | 404 | 2,9 | 0 | 0 | 103 | 5,3 | 0 | 1045 | 0 | 99881 | 0 | 134 | 1 | 0,02 | 28473 | 3,2 | 2,95 | 1400 |
| 8 | 92622 | 1748 | M | 79 | 46.0 | 179 | 74,4 | 25,6 | 166 | 176 | 391 | 404 | 2,9 | 0 | 0 | 103 | 5,3 | 0 | 1045 | 0 | 99881 | 0 | 134 | 1 | 0,02 | 28473 | 3,2 | 2,95 | 1400 |
| 9 | 85009 | 1748 | M | 79 | 46.0 | 179 | 72 | 23,58 | 144 | 154 | 338 | 338 | 25,7 | 0 | 0 | 100,9 | 3,4 | 0 | 844 | 0 | 76791 | 0 | 95 | 1 | 0,02 | 23620 | 2,69 | 2,54 | 1300 |
Last rows
| df_index | user-id | m/v | weight | age | length | total distance (km) | average speed (km/h) | uphill/downhill hys=8 (m) | uphill8end | uphill/downhill hys=0 (m) | uphill0end | average temperature | average wind speed (m/s) | average wind direction (deg) | max/min gpx height | maxgpsheight | total real energy (kJ) | total estimated energy (kJ) | average power (W) | average estimated power (W) | normalized real power (W) | normalized estimated power (W) | number_of_participants | average wind load (1 to -1) | cumulative hr intensity score | avg_heart_rate_cat_org | avg_heart_rate_cat_adj | avg slope length (m) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167612 | 75239 | 1812 | M | 78 | 54.0 | 178 | 88 | 30,76 | 90 | 99 | 305 | 317 | 25,2 | 0 | 0 | 57,6 | 1,2 | 2294 | 1697 | 224242 | 165921 | 218 | 215 | 11 | -0,03 | 55078 | 3,63 | 3,6 | 1500 |
| 167613 | 74745 | 1812 | M | 78 | 54.0 | 178 | 64,5 | 31,21 | 126 | 91 | 362 | 331 | 29,2 | 0 | 0 | 68,3 | -1,2 | 1588 | 1203 | 214088 | 162243 | 230 | 201 | 9 | -0,06 | 53781 | 4,63 | 4,21 | 1500 |
| 167614 | 74225 | 1812 | M | 78 | 54.0 | 178 | 88,8 | 36,33 | 217 | 226 | 501 | 510 | 19,2 | 0 | 0 | 60,6 | 5,2 | 2154 | 1989 | 244865 | 226041 | 261 | 287 | 9 | -0,17 | 55621 | 6,2 | 5,82 | 1100 |
| 167615 | 74265 | 1812 | M | 78 | 54.0 | 178 | 115,5 | 36,95 | 450 | 219 | 706 | 467 | 20,4 | 0 | 0 | 307,1 | 49,2 | 2730 | 2595 | 242596 | 230628 | 266 | 280 | 19 | -0,51 | 69254 | 6 | 5,62 | 14000 |
| 167616 | 75174 | 1812 | M | 78 | 54.0 | 178 | 88,1 | 29,59 | 249 | 252 | 572 | 580 | 14,2 | 0 | 0 | 78,3 | 2,3 | 0 | 1492 | 0 | 139298 | 0 | 185 | 1 | 0 | 34191 | 3,63 | 3,21 | 1600 |
| 167617 | 75221 | 1812 | M | 78 | 54.0 | 178 | 84,6 | 28,53 | 76 | 64 | 329 | 319 | 17,1 | 0 | 0 | 48 | -8,6 | 0 | 1328 | 0 | 124410 | 0 | 153 | 1 | 0 | 48124 | 4,83 | 4,3 | 1000 |
| 167618 | 75170 | 1812 | M | 78 | 54.0 | 178 | 160,9 | 26,85 | 992 | 985 | 1524 | 1525 | 17,2 | 0 | 0 | 748,7 | -37,2 | 0 | 2604 | 0 | 121007 | 0 | 203 | 1 | 0 | 83028 | 3,91 | 3,53 | 21600 |
| 167619 | 75181 | 1812 | M | 78 | 54.0 | 178 | 78,8 | 30,43 | 162 | 159 | 531 | 530 | 17,4 | 0 | 0 | 60,2 | 3 | 0 | 1400 | 0 | 150396 | 0 | 184 | 1 | 0 | 28577 | 3,57 | 3,18 | 1100 |
| 167620 | 74919 | 1812 | M | 78 | 54.0 | 178 | 70 | 30,37 | 100 | 95 | 286 | 286 | 17,9 | 0 | 0 | 51,2 | 10,4 | 0 | 1171 | 0 | 141171 | 0 | 164 | 1 | 0 | 22958 | 3,4 | 3,02 | 1200 |
| 167621 | 74991 | 1812 | M | 78 | 54.0 | 178 | 72,4 | 26,74 | 397 | 406 | 651 | 667 | 18,2 | 0 | 0 | 327 | -18,5 | 0 | 1098 | 0 | 112608 | 0 | 185 | 1 | 0 | 23768 | 3,04 | 2,82 | 7300 |